A poor logical database design can hinder the performance of the whole system 邏輯數(shù)據(jù)庫(kù)設(shè)計(jì)不好,會(huì)影響整個(gè)系統(tǒng)的性能。
Sometimes , the logical database design is already fixed and total redesign is not realistic 有時(shí),邏輯數(shù)據(jù)庫(kù)設(shè)計(jì)已經(jīng)固定,全部進(jìn)行重新設(shè)計(jì)是不現(xiàn)實(shí)的。
A good logical database design can lay the foundation for optimal database and application performance 設(shè)計(jì)好邏輯數(shù)據(jù)庫(kù),可以為優(yōu)化數(shù)據(jù)庫(kù)和應(yīng)用程序性能打下基礎(chǔ)。
Normalizing a logical database design involves using formal methods to separate the data into multiple , related tables 規(guī)范化邏輯數(shù)據(jù)庫(kù)設(shè)計(jì)包括使用正規(guī)的方法來(lái)將數(shù)據(jù)分為多個(gè)相關(guān)的表。
After normalizing your data model as far as you have intended during the logical database design process , then include some degree of de - normalization as one of the potential performance tuning options 在邏輯數(shù)據(jù)庫(kù)設(shè)計(jì)過(guò)程中,您可以毫無(wú)保留地規(guī)范化數(shù)據(jù)模型,然后再加入一定程度的反規(guī)范化,作為潛在的性能調(diào)優(yōu)的一種選擇。
The thesis also analyzes how to optimize the performance of the whole distance education supporting platform based on sql server7 . 0 database , and emphasizes on the four aspects of logical database design , index usability , query structure and procedure objects . it also discusses the extension of system functions from the point of view of database design in order to realize the distance education quality appraisal and tracking in the future 對(duì)基于sqlserver7 . 0數(shù)據(jù)庫(kù)的整個(gè)遠(yuǎn)程教育支撐平臺(tái)系統(tǒng)的性能優(yōu)化進(jìn)行分析,著重從邏輯數(shù)據(jù)庫(kù)設(shè)計(jì)、索引的可用性、查詢結(jié)構(gòu)和過(guò)程對(duì)象的使用四個(gè)方面進(jìn)行論述,并從數(shù)據(jù)庫(kù)設(shè)計(jì)角度討論了對(duì)系統(tǒng)進(jìn)行功能擴(kuò)展,以實(shí)現(xiàn)未來(lái)對(duì)遠(yuǎn)程教育質(zhì)量評(píng)價(jià)和教學(xué)質(zhì)量跟蹤。